Table of Contents

Moscow public catering establishments market research

Research purpose

Explore the market of public catering establishments in Moscow and find interesting features that will help in choosing a suitable place to open a new establishment.

Research description

Investors of the Shut Up and Take My Money fund decided to open a catering establishment in Moscow. The location, menu, prices and type of establishment have not yet been determined.

The task is to prepare a study of the Moscow market, find interesting features and present the results obtained, which willl help investors to choosie a suitable place. We have a dataset with public catering establishments in Moscow, compiled on the basis of data from Yandex Maps and Yandex Business services for the summer of 2022.

Data description

File moscow_places.csv:

Data preprocessing


There are 8406 establishments in operation. No duplicates were found. There are gaps in secondary values - at this stage of the work we do not fill them in. It may not be necessary in the future.

Creating a "street" column with street names

Creating a column "is_24/7" with for round-the-clock and daily establishments

Adjusting the name column

Adjusting the category column

Interim summary

There are 8406 establishments in operation. No duplicates were found. There are gaps in secondary values - at this stage of the work we do not fill them in. It may not be necessary in the future.

The gaps in the hours - 536 values make 6%. In the conditions of this experiment, this amount can be ignored. Working hours are not a critical characteristic in the study. The gaps in each of the price, avg_bill, middle_avg_bill, middle_coffee_cup columns are more than 60%, such losses are irreplaceable, and also these data are not critical in the study, since we were not tasked with determining the exact cost of a cup of coffee. And to define the general concept of the price category, this data is enough. The gaps in the seats column account for more than a third - these data are also not the subject of detailed study in this study.

The names are reduced to lowercase to reduce non-obvious duplicates.

The categories of chain establishments are reduced to one value.

Data analysis

Establishments category distribution


Number of seats in establishments by category visualization


Network and non-network establishments ratio


Categories of chain establishments research


Making a list of the top 15 establishments

We build the corresponding histogram of the most popular establishments


Establishments, in addition to their popularity, are united by the following factors:

Among the Top 15 chain establishments in Moscow, the first place is the coffee shop Chocolate, pizzeria, Yandex-Shop restaurant, and budget coffee shops

Distribution of establishments of each category by administrative districts of Moscow


Distribution of average ratings by categories of establishments


Cartogram of Moscow districts with an average rating of establishments


Establishments on the map of Moscow

Top 15 streets by number of establishments

Distribution chart of number of establishments and their categories by Top-15 streets


Streets with a single catering facility


Total streets with one institution in Moscow - 458 It is typical for such establishments:

The effect of distance from the center on prices in establishments


The distance from the center does not affect the average check.
The average check is determined by the status of the district. In more expensive/elite/historical areas, the prices are higher - the Eastern AD is on a par with the Centeal AD here

Dependence of the opening hours of establishments on the location and category of the institution


The map of round-the-clock establishments mirrors the map of prices and ratings.
The more disadvantaged the area, the more round-the-clock establishments - Eastern Administrative District, SEAD
The smallest part of round-the-clock establishments in the Central AD

Distribution of establishments with poor ratings by districts and categories


Average check of establishments with poor ratings by category


Interim summary


Details of the study "opening a coffee shop"

Distribution of coffee shops by districts and features of their location

24-hour coffee shops

Distribution of coffee shop ratings by district

Average cost of a cup of cappuccino by district

Interim summary

The number of coffee shops in the dataset is 1380
Most coffee shops in CAD - 425, NAD - 190, NEAD - 148, WAD - 142
The number of round-the-clock coffee shops in Moscow is 53
The best rating of coffee shops in CAD, NWAD, the lowest - WAD, SAD, NEAD


General recommendation for opening a new coffee shop

Consider for a coffee shop the areas with the lowest ratings and the most sparsely populated coffee shops, which means with the most uncompetitive environment
**NAD NEAD SAD

The average cost of a cup of cappuccino in these areas: WAD - 195₽
NEAD - 165₽
SAD - 160₽

Recommendation for opening a new coffee shop. Option 1

Consider coffee shops in the areas selected above.
We will look for the street with the least number of competitors, where there is only one institution on the street


Based on the small number of such streets - 17, it will be easy to choose the most passable ones with the help of third-party data

Recommendation for opening a new coffee shop. Option 2

Consider the 200 most popular streets in Moscow where there are no coffee shops


17 streets is also a small number, it will be easy to choose from it.
You can additionally impose restrictions on the above selected areas.
Or, depending on the business plan, focus on areas for the price of a cup.


Presentation: https://disk.yandex.ru/i/kGR5OggR9x2a4g